Leibel S Community Champion

Overview

Overview

Roles	Member
Badges	33

About Me

About Me

Area of Expertise
About Me
How I Use Smartsheet
Linkedin
Twitter Page

Analytics

848

Posts

1,548

Visits

10.9k

Points

Oct 12, 2020

Join Date

Mar 7, 2025

Last Active

Reactions

• Promote 1

  1
• Insightful 42

  42
• Vote Up 247

  247
• Awesome 72

  72

• Activity
• Discussions6
• Comments842

• Re: Maxif Next Date to Review

  Leibel S

  02/04/25
  @Pestomania You would use a MAX(COLLECT()) Combo. So something like this: =MAX(COLLECT([Date]:[Date],[Document Name]:[Document Name],@cell=[Document Name]@row))
  2 ·

• Re: Count Distinct names, multiple columns, on specific dates

  Leibel S

  01/07/25
  @Dominick Vargas My suggestion would be to make a column that combines all 3 fields (cashier restock and delivery). Lets call it All with a formula of: =JOIN(Cashier@row:Delivery@row, CHAR(10)) then …
  1 ·

• Re: Pull value from cell to a new cell, and it won't change even if source value changes

  Leibel S

  01/07/25
  You can add a date column in your team employees sheet that has a formula =TODAY() Then make an automation that copies the rows to the logistics sheet every month on the first
  1 ·

• Re: can i use sumif formula with my criteria referencing a cell in my sheet?

  Leibel S

  12/06/24
  Try this: change to SUMIF to SUMIFS Change = to @cell=
  1 ·

• Re: Formula Help

  Leibel S

  12/04/24
  just change it to: =IF([DocuSign Status]@row = "Sent", "Pending Sig. Approval", "")
  1 ·

Next